<%@ page import="java.sql.ResultSet"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" 
pageEncoding="UTF-8"%>
<%@ page import="java.util.*" %>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html PUBLIC"-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>人员信息</title>
</head>
<body>
<center>
<s:form action="EmployeesAction" method="post" theme="simple">
姓名首字母：<s:textfield name="PY"/>
职称：<s:select  name="CareerId" list="#{'0':'==请选择==','1':'学生 '}"/>
部门：<s:select name="DeptId"  list="#{'0':'==请选择==','1':'数信学院'}"/> 
<s:submit value="查询"/>
</s:form>
<br>
<s:form action="EmInsertOrDelete" method="post" theme="simple">
<table border=1px;>
<tr><td>人员编号</td><td>姓名</td><td>部门</td><td>实验室</td><td>职称</td><td>职称取得时间</td><td>学位</td><td>手机长号</td><td>手机短号</td><td>办公室电话</td><td>描述</td></tr>
<s:iterator value="employees" id="em" >
<tr>
<td ><s:property value="#em.EmId"/></td>
<td><s:property value="#em.EmName"/></td>
<td><s:property value="#em.DeptId"/></td>
<td><s:property value="#em.ThreeDeptId"/></td>
<td><s:property value="#em.CareerId"/></td>
<td><s:property value="#em.CareerDate"/></td>
<td><s:property value="#em.DegreeId"/></td>
<td><s:property value="#em.LongMobile"/></td>
<td><s:property value="#em.ShortMobile"/></td>
<td><s:property value="#em.OfficePhone"/></td>
<td><s:property value="#em.Memo"/></td> 
</tr>
</s:iterator>
</table>
<br>
<table >
<tr>
<td><s:submit name="insert" value="增加房间"/></td> 
<td><s:submit name="delete" value="删除"/></td>
</tr>
</table>
</s:form>
</center>
</body>
</html>